Views are useful for allowing users to access a set of relations (tables) as if it were a single table, and limiting their access to just that. Views can also be used to restrict access to rows (a subset of a particular table).
Just simply click to open an object pane for View.
By using the object pane toolbar below, you can create new, edit, open and
delete the selected view.
Create View
To create a new view
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New View from the popup menu.
- Edit view properties on the appropriate tabs of the View Designer.
Hint: To create new view you can also control-click the Views node of the navigation pane and select the New View from the popup menu.
To create a new view with the same properties as one of the existing views has (using popup menu)
Apply to: current database {same connection}
- Select the view(s) for copying in the navigation pane/object pane.
- Control-click and select the Duplicate View from the popup menu.
- The newly created view(s) will be named as "viewname_copy".
To create a new view with the same properties as one of the existing views has (using drag and drop method)
Apply to: current schema {same connection}
- Select the view(s) for copying in the navigation pane/object pane.
- Click and drag the chosen view(s) to the target location.
- Select one of the following options:
- Copy
- Cancel
- The newly created view(s) will be named as "viewname_copy".
Apply to: different schema {same connection} different schema {different connection} (Data Transfer tool will be activated)
- Select the view(s) for copying in the object pane.
- Drag and drop the chosen view(s) to the target database.
- Select one of the following options:
- Copy
- Cancel
To create a new view with modification as one of the existing views
- Select the view for modifying in the navigation pane/object pane.
- Control-click and select the Design View from the popup menu.
or - Click the
from the object pane toolbar.
- Modify view properties on the appropriate tabs of the View Designer.
- Click
Save As.
To create a new view with loading from a SQL file
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New View from the popup menu.
- Click
Load.
Edit View
To edit the existing view (manage its SQL definition etc)
- Select the view for editing in the navigation pane/object pane.
- Control-click and select the Design View from the popup menu.
or - Click the
from the object pane toolbar.
- Edit view properties on the appropriate tabs of the View Designer.
To change the name of the view
- Select the view for editing in the navigation pane/object pane.
- Control-click and select the Rename from the popup menu.
To open a view (manage view data)
- Select the view for opening in the navigation pane/object pane.
- Control-click and select the Open View
from the popup menu or simply double-click the view.
or - Click the Open from the object pane toolbar.
Maintain View
To maintain a view
- Select the view for maintaining in the object pane.
- Control-click and select the Maintain from the popup menu.
- Compile
Delete View
To delete a view
- Select the view for deleting in the navigation pane/object pane.
- Control-click and select the Delete View from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve View Information
To achieve a view information
- Select the view in the navigation pane/object pane.
- Choose View -> Object Information in the main menu.
or - Click the
from the object pane toolbar.